Aggregate - MaxNum

MaxNum Aggregate Functoid

Description: The MaxNum Aggregate Functoid will return the largest numeric value within the records provided to the input Field for the entire table or in case that a group functoid has been used the largest numberic value of the records within each group. Inputs with their allowed values:

Picture of the MaxNum Aggregate Functoid

 
Remark: Any non-numeric values passing through wil cause an empty return value. Example: Example 1: Table with group by
Group By Values Result of MaxNum
Group1 2 4
Group1 4 4
Group2 3 7
Group2 7 7
See Figure 1.

Figure 1